package com.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.model.UsersPersonal;
import org.apache.ibatis.annotations.Select;


/**
 * <p>
 * 个人信息表  Mapper 接口
 * </p>
 *
 * @author Damon
<<<<<<< HEAD
 * @since 2021-04-29
 */
public interface UsersPersonalgerenDao extends BaseMapper<UsersPersonal> {
    //查询员工信息以及部门名称
//    @Select("SELECT * from users_personal")
    @Select(" SELECT b.id,b.realname,b.email FROM users a LEFT JOIN users_personal b ON (a.user_account=b.user_account) where 1=1 and a.type=3")
    public Page<UsersPersonal> listPage(Page page);
}

